Online Training/Webinar in Microsoft Excel

Learn From Any Location

Not just another online course. Our instructors are visible in real-time and will train you in the latest Microsoft Excel courseware.

Fall Special - $99 Per Webinar (Normally $129)

Webinars

Webinars are instructor-led "virtual classrooms" where the student can communicate live with the instructor just like a real classroom! All you need is a computer with internet access and a short period of time you can invest in yourself.

Depending on the course you choose, the GK Training Team will be presenting topics that range from beginning to advanced Excel. (Beginners click here)

We are offering nine webinars, each session is two hours.

• Webinar #1: PivotTables and Pivotcharts
  • Create a PivotTable
  • Analyze a PivotTable
  • Present data with PivotCharts
  • Filter Data
• Webinar #2: Working with Advanced Formulas
  • Vlookup
  • Using range names in formulas
  • Logical functions (If, Countif)

• Webinar #3: Working with Multiple Worksheets
  • linking data within workbooks
  • Use links with external references (links to web pages, e-mail)
  • Consolidate data
• Webinar #4: Automating Workbook Functionality
  • Work with Macros
  • Creating a Form Template
  • Protecting a Worksheet

• Webinar #5: Pie Charts Utilizing Percentage Formulas
  • Create Percentage Formulas
  • Creating and Formatting a Pie Chart
  • Using 3-D, Shadow Effects
  • Exploding a Pie Slice
• Webinar #6: Organizing Data with Tables
  • Sort data
  • Filter data
  • Freeze Panes
  • Use Statistical Functions (Average, Count, Max, Min)

Beginning Level Webinars

• Webinar #7: Create a Worksheet and Chart
  • Save and navigate an Excel Workbook
  • Understanding the Excel Ribbon
  • Enter data in a Worksheet
  • Construct formulas using the SUM function
  • Create a Column Chart
  • Print a Worksheet
• Webinar #8: Performing Calculations
  • Learning Formulas with Operators (multiply, subtract and divide)
  • Copying formulas
  • Calculating percentages
  • Editing values in a worksheet
• Webinar #9: Formatting a Worksheet
  • Aligning cell contents
  • Applying cell styles
  • Centering titles and merging cells
  • Number formatting
• Webinar #10: Printing and Managing Workbooks
  • Learn print features such as scaling
  • Control how workbooks print
  • Worksheet tabs
  • Deleting/Renaming Worksheets
  • Moving and Copying Worksheets

 

Fill out the form below, indicate the webinar you inare interested in attending, and click submit. Someone will contact you to finalize course details.

Select Webinar from the list: Webinar #1: PivotTables and PivotCharts Webinar #2: Working with Advanced Formulas Webinar #3: Working with Multiple Worksheets Webinar #4: Automating Workbook Functionality Webinar #5: Pie Charts Utilizing Percentage Formulas Webinar #6: Organizing Data with Tables Webinar #7: Creating a Worksheet and Chart Webinar #8: Performing Calculations Webinar #9: Formatting a Worksheet Webinar #10: Printing and Managing Workbooks

First Name:

Last Name:

City/Town:

Contact Phone:

Best time to be contacted:

E-mail:

Date of Seminar (Any weekday M-F Excluding Holidays):

Training time 9-11 am (select box):

Training time 11-1 pm (select box)

Sample Webinar with Live Instruction and Attendees